package com.ming.dao;

import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import com.ming.pojo.Package;
import java.util.List;

/**
 * @author Xu
 * Created by Intellij IDEA.
 * @create 2021/4/14 21:22
 */
@Mapper
@Repository
public interface PackageMapper {
    public int addPackage(Package _package);

    public int deletePackage(int pid);

    public int updatePackage(Package _package);

    public Package queryPackageById(int pid);

    public List<Package> queryPackages();

    List<Package> queryStaffPackages(int sid);
    List<Package> queryCustomerPackages(int cid);
    List<Package> queryRecipientPackages(int rid);

    Integer getMId();

    Integer getCidByName(String pname);
}
